﻿CREATE TABLE [dbo].[Employer] (
    [EmployerId]      UNIQUEIDENTIFIER NOT NULL,
    [EmployerName]    NVARCHAR (300)   NOT NULL,
    [EmployerProfile] NTEXT            NULL,
    [Email]           VARCHAR (100)    NULL,
    [Website]         VARCHAR (100)    NULL,
    [Phone]           VARCHAR (15)     NULL,
    [Fax]             VARCHAR (15)     NULL,
    [State]           INT              NULL,
    [EmployerTypeId]  INT              NULL,
    CONSTRAINT [PK_Company] PRIMARY KEY CLUSTERED ([EmployerId] ASC),
    CONSTRAINT [FK_Employer_EmployerType] FOREIGN KEY ([EmployerTypeId]) REFERENCES [dbo].[EmployerType] ([EmployerTypeId])
);





